SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vwlrelevamientoconstrucciones
AS
SELECT     dbo.u_f2_00_varios.Id, dbo.u_f2_00_varios.idCui, dbo.u_f2_00_varios.observaciones, dbo.u_f2_00_varios.anioMayorParteConstruccion, 
                      dbo.u_cui.direccion, dbo.u_f2_00_varios.construccion, dbo.u_f2_00_varios.subsuelo, dbo.u_f2_00_varios.plantabaja, dbo.u_f2_00_varios.plantaalta, 
                      dbo.u_f2_00_varios.totalPlantas
FROM         dbo.u_f2_00_varios INNER JOIN
                      dbo.u_cui ON dbo.u_f2_00_varios.idCui = dbo.u_cui.Id
GO
GRANT SELECT ON  [dbo].[vwlrelevamientoconstrucciones] TO [Cenie]
GO
